package com.sakura.system.dao.yzcdao;


import com.sakura.system.entity.yzc.SysBill;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SysBillMapper {

    List<SysBill> findAllBills(SysBill sysBill);

    @Select("select * from sys_bill where bill_id = #{id}")
    SysBill findBillById(@Param("id") Long id);

    int addBill(SysBill sysBill);

    int updateBill(SysBill sysBill);

    int deleteBill(Long id);

    @Select("select * from sys_bill where cancel_state = 0 and pay_state = 0")
    List<SysBill> findTimeoutBill();

}
